Navicat provides you a useful tool for restoring your backup while hardware failure occurs.
To open a restore windows (see Restore Backup for details).
Note: You must have Create, Drop and Insert Privileges (MySQL or PostgreSQL) to run the restore.
Hint: Restore function will firstly drop the selected objects of the database, then recreate the new objects according to your backup. Finally, inserting the data.
To restore a backup with default settings from the command line
- In terminal, type the command (see Command for details)
See also:
Backup
Execute SQL File